Framework for Client-Server Distributed Database System for Licensing and Registration of Automobiles in Nigeria

Registration is the process of adding a vehicle to the Motor Vehicle Register and issuing it registration plates. Vehicle licensing is the payment of a fee for the use of a motor vehicle on public roads. In recent times, it has been observed that a reduction in Nigerian government internally generated revenue is in part a result of the evasion of automobile vehicle property and usage taxes by individuals who abuse or circumvent the state's automobile registration system. In this research work, an attempt is made to design a framework for a client server distributed database system for licensing and registration of automobiles in Nigeria. The system consists of a relational database of automobile decision variables which could be shared by the three level organizations, viz, Vehicle Inspection Office (VIO), Federal Road Safety Commission, and the Board of Internal Revenue. Each of these organizations is considered as a site. The Database is expected to be hosted by the VIO while the concept of data replication and fragmentation is adopted by other sites to have access to data/records in the database. The system is intelligent and capable of checking to detect multiple registrations, registration of stolen automobiles, malicious registrations, registration of damaged or reformed automobiles, and fictitious registration. The system is capable of generating reports for decision makers to enable monitoring and enforcement. (